A Data Mart is a subject-oriented database that supports the business needs of department-specific business managers.
(or)
A Data Martin Informatica is a subject of an enterprise data warehouse a data mart is also known as high-performance query structures (HPQS)s.
There are two types of data mart
|
EDW |
Data Mart |
|
1. It defines a single subject |
|
2. It stores department specific information |
|
3. design for middle management users |
If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.
According to the Inman first we need to build an enterprise data warehouse, from the EDW design subject oriented, department specific database known as data marts.
According to the Kimball design department specific, subject oriented database know as data marts, integrate the data marts to define enterprise data warehouse
In a top-down approach a data mart development “dependants” on enterprise data warehouse hence data mart are know as dependent data mart.
In a bottom-up approach a data mart development is “Independent” of enterprise data warehouse. Hence such data mart are know as independent data mart.
An Operational Data Store (ODS) is an integrated database of operational data. Its sources include legacy systems and it handles current or any near term data. An ODS may contain 30 to 60 days of information, while a data warehouse typically contains years of data.
An operational data store is basically a database that is used for being an interim area for a data warehouse. As such, its primary purpose is for handling data which are progressively in use such as transactions, inventory and collecting data from Point of Sales. It works with a data warehouse but unlike a data warehouse, an operational data store does not contain static data. Instead, an operational data store contains data which are constantly updated through the course of the business operations.
|
ODS |
DSS (Decision Supporting System)DWH |
| Similarity:- Integrated database | Similarity:- Integrated data base |
Differences:- 1. Volatile data
|
Difference:-1. Volatile data2. Historical data3. summary data |
Informatica Power Center is a single unified data integration platfom, which allows company and organization to access the data from various type of source system transforming the data in to a homogeneous format and delivers the data through the enterprise at any speed.
Informatica Power Center is a client server technology and integrated tool set used to for designing running, monitoring and administrating that data acquisition application known as “mappings”.
A mapping is a graphical represent of data flow from source to target.
For indepth understanding of Informatica click on
Router Transformation in Informatica
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
